UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZP7KTBCx8WEy2+nPOu+mhYlnYlW/DOzHIvvSxOE4sHI='
WHERE
key_id = 'ee6653d520e5ab2d51bef37f215692aee8eb96cab61e485571475a957daf512e'
AND (
token = 'ZP7KTBCx8WEy2+nPOu+mhYlnYlW/DOzHIvvSxOE4sHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)