UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EsIVSj2RIbnSOvsqs364JCVn8d8aXJ8PO1TUay+i5XI='
WHERE
key_id = '7528636ef9d6cf9b61ea679d6e59dd57d6b9068e81fd4ba5d45b51a8d174aa28'
AND (
token = 'EsIVSj2RIbnSOvsqs364JCVn8d8aXJ8PO1TUay+i5XI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)