UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qJBHOV+hVGMdlN9hLL7vtAg1R/ag55IAw4Bum8DZPFg='
WHERE
key_id = '8c9520813549cf97ca8ba6156f496a69095db85a6e63d9764dfcb763d8b1c4fc'
AND (
token = 'qJBHOV+hVGMdlN9hLL7vtAg1R/ag55IAw4Bum8DZPFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)