UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eHuUbE8nnh4yKvTzUP/T72oqQtee2qyQTpzNnO31he0='
WHERE
key_id = 'cb14c3f13f675e7cc6fe0661832b3b00c574c47a0b5fe46740b611fee53ac993'
AND (
token = 'eHuUbE8nnh4yKvTzUP/T72oqQtee2qyQTpzNnO31he0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)