UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGOOFG7KK/AuP7X+voZk4QvtpMEI/o22WLVqOm+Yzl4='
WHERE
key_id = 'a74d39790634391a42ce689781dc823322724b80bd77677bf8438fe3a15438c4'
AND (
token = 'CGOOFG7KK/AuP7X+voZk4QvtpMEI/o22WLVqOm+Yzl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)