UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2OyDw4jK/nrZgcVKuvDDQ/3lr47INFsgsAYD8lUTqvI='
WHERE
key_id = '9601461988a00b292b7709ab083568cef0e57dfb712753627971f6d6e0fc3837'
AND (
token = '2OyDw4jK/nrZgcVKuvDDQ/3lr47INFsgsAYD8lUTqvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)