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