UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3FL7mNj9PyuHiA1HzBORMNUCPifPkAcouqCH4tPsEFs='
WHERE
key_id = 'e726e437538854d3748c3889add29aca03933b2b36afae835a3fcd99e7dd19f6'
AND (
token = '3FL7mNj9PyuHiA1HzBORMNUCPifPkAcouqCH4tPsEFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)