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