UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2JThZ07fbopFNJYrRjbgMZUF2YJIk2ouIC12cR8WSj4='
WHERE
key_id = '07a26e457eeccd3f91c2ac3f020a08352e14f1d9d166e7deb98f3e2634a63dec'
AND (
token = '2JThZ07fbopFNJYrRjbgMZUF2YJIk2ouIC12cR8WSj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)