UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vW1PqazaEnUfjMHGCjxI562pJ5aViW6yVN48CCRtMXE='
WHERE
key_id = '1abc8f25f1c1f9a7052c96a79376828927005226bc8d5ff4f65eeedae8848337'
AND (
token = 'vW1PqazaEnUfjMHGCjxI562pJ5aViW6yVN48CCRtMXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)