UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xSzqtzHVmv9VHriukeHoSrEOD504Vb+jEykX3FwjxxU='
WHERE
key_id = 'e905bd741e690027d3e650428b52376d2f8c501fd61ae4abea1f03e95f10fbad'
AND (
token = 'xSzqtzHVmv9VHriukeHoSrEOD504Vb+jEykX3FwjxxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)