UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WYxqSI0lDzhkGKqzASsgbnegXzdTucx4ooYJ8KOtTUA='
WHERE
key_id = 'df7205f9b3a04b93f5ca607246debb3e4a8b5e92fca7ad6f6d164aa5f67f3af4'
AND (
token = 'WYxqSI0lDzhkGKqzASsgbnegXzdTucx4ooYJ8KOtTUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)