UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kLhUQwafClwviZS+BJjLrEX6e4CZ/7itso0mpuvZeY8='
WHERE
key_id = 'c200d14477491960a801f75d907ab3cb6eabe6d30d5b67b38e560e7e71d34f8e'
AND (
token = 'kLhUQwafClwviZS+BJjLrEX6e4CZ/7itso0mpuvZeY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)