UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'frorAcGYCot8FPOA/vAmxaeM51RAjyDMykUaCia7mLc='
WHERE
key_id = 'efd67bf09d4713e8fb25de5f80c55a56f580c67da81f52580c8bc26555ff8bb7'
AND (
token = 'frorAcGYCot8FPOA/vAmxaeM51RAjyDMykUaCia7mLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)