UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'afI9bPnIQStulAfwvNQQRfOFGOSm67tcvexEc2KQcqY='
WHERE
key_id = '2891e1b82ac3b8bdda83ec2d5962f6f1b80decd1725a6d69e1ce879d1fde1cb4'
AND (
token = 'afI9bPnIQStulAfwvNQQRfOFGOSm67tcvexEc2KQcqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)