UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3iTjj81hr6QGi7kAwsKIO5GABRCJV2p+mzQ3023tYM0='
WHERE
key_id = '294612826a8c2ffdce3a7e88f81a96e122345cc94c52ecd3230c0b5a8490e9a0'
AND (
token = '3iTjj81hr6QGi7kAwsKIO5GABRCJV2p+mzQ3023tYM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)