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