UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UozdLYh/mW+RMfVmxsWTgk8fbwayMr45ICXa0RWLEGM='
WHERE
key_id = '0466cafcd63a2e4cb16a11b864a4456d81269be00e5b67bc4915b9718838017e'
AND (
token = 'UozdLYh/mW+RMfVmxsWTgk8fbwayMr45ICXa0RWLEGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)