UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vnvavTlVh4rTwe/ojQmIZ1GpnCE6EndYGtly4t0yKzc='
WHERE
key_id = 'f492a92befc97441f6cc67d6d6333da8d14a7510823c497514533a0a257852a9'
AND (
token = 'vnvavTlVh4rTwe/ojQmIZ1GpnCE6EndYGtly4t0yKzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)