UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dikhaiEnqL1o0EjTKaYDMO2oOwh/svfpTM722CH9HK8='
WHERE
key_id = 'e46a0548af47ac58859c8eb2515de84650e3375347ad30da0db1cdea2a6abe70'
AND (
token = 'dikhaiEnqL1o0EjTKaYDMO2oOwh/svfpTM722CH9HK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)