UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3A/Eq8StS4iH8WI3gcae0DNLVHHHlvNcMKVujFz4U9I='
WHERE
key_id = '4321112f43a5b4727c3b29587f4726509757469836d03ca61d1f4d7796bb97de'
AND (
token = '3A/Eq8StS4iH8WI3gcae0DNLVHHHlvNcMKVujFz4U9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)