UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '99g67G6iNQGt89iVP5p+ORf90/tE6R/4T4hRhbTLq1E='
WHERE
key_id = 'e7caf284ee21782c181d4323967d794c5b001390f1d4c879115b4bc48e7450ae'
AND (
token = '99g67G6iNQGt89iVP5p+ORf90/tE6R/4T4hRhbTLq1E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)