UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '87xZubgD7kL/088k72IMebXobiJprRL+Ylr/cgG4VRs='
WHERE
key_id = 'ddd449e340937b6dc93499fb09e3b7d3eeed6740b1b8d91bc1b8d007319b01a2'
AND (
token = '87xZubgD7kL/088k72IMebXobiJprRL+Ylr/cgG4VRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)