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