UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1UHOiC3ClIY9aDrEKvG8H6Y0K6lLb1jdE892ZRn0Px0='
WHERE
key_id = 'b7756efb867dc1c9b7c5a5dceac9294615623c2c9be95396a1733c9544c5cbf3'
AND (
token = '1UHOiC3ClIY9aDrEKvG8H6Y0K6lLb1jdE892ZRn0Px0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)