UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oAOsCffZz8iVHlpptpPckSGuRmS50RlbQIoxI2eqjes='
WHERE
key_id = 'e3f6f69aec28516bc79f82ec29ae6f59f3bee935baf2bf1045a0df582b43fe25'
AND (
token = 'oAOsCffZz8iVHlpptpPckSGuRmS50RlbQIoxI2eqjes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)