UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KAPe3cgR6eMZWeQXqVbchypijSOlU5wxA57ZPw8xJqg='
WHERE
key_id = '0c4e6bba5d5ae905b47768e7e4aa508306c9397574ac6cd3bb7784fa26f4724e'
AND (
token = 'KAPe3cgR6eMZWeQXqVbchypijSOlU5wxA57ZPw8xJqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)