UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vq9z0XwuLDGtIvC/6zXnKaE3CbICgVMBfHwaxyeXSIo='
WHERE
key_id = 'c764b6be2365955160de9988a8a8ee6049cd2b22c6d8d826a57da3fc4bd20281'
AND (
token = 'Vq9z0XwuLDGtIvC/6zXnKaE3CbICgVMBfHwaxyeXSIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)