UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UbYLS5pcYNHDH3+japi40NnS0do5npcOZa+ttFTFNcU='
WHERE
key_id = '71516bd87b936fc12747ebde1de45ff22e4e09d4bf1940bdeaa7c1fc565ccf03'
AND (
token = 'UbYLS5pcYNHDH3+japi40NnS0do5npcOZa+ttFTFNcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)